drop table member;

create table member(
	m_uid number primary key,
	m_id varchar2(100) not null,
	m_password varchar2(50) not null,
	m_nickname varchar2(30) not null,
	m_level number not null,
	m_pro_imgname varchar2(300) not null
);


drop sequence member_seq;
create sequence member_seq nocache;

insert into member(m_uid,m_id,m_password,m_nickname,m_level,m_pro_imgname) values(member_seq.nextval,'kjh@naver.com','1234','a','99','a.jpg');
insert into member(m_uid,m_id,m_password,m_nickname,m_level,m_pro_imgname) values(member_seq.nextval,'yhs@naver.com','1234','b','99','b.jpg');
insert into member(m_uid,m_id,m_password,m_nickname,m_level,m_pro_imgname) values(member_seq.nextval,'sys@naver.com','1234','c','99','c.jpg');
insert into member(m_uid,m_id,m_password,m_nickname,m_level,m_pro_imgname) values(member_seq.nextval,'jyj@naver.com','1234','d','99','d.jpg');
insert into member(m_uid,m_id,m_password,m_nickname,m_level,m_pro_imgname) values(member_seq.nextval,'jky@naver.com','1234','e','99','e.jpg');
insert into member(m_uid,m_id,m_password,m_nickname,m_level,m_pro_imgname) values(member_seq.nextval,'kkk@naver.com','1234','f','99','f.jpg');



select * from member;

























